{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Учет данных","Статистика","Прогнозирование","БД","Справочник","for_code"],"not_rendered":{"charts":17,"images":4,"macros":1,"external_links":1,"defined_names":40,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Учет данных","index":0,"n_rows":46,"n_cols":24,"rows_kept":46,"cut":false,"hidden":false,"merged":[[40,18,43,19],[44,18,45,19],[28,14,28,15],[4,13,4,14],[45,7,45,8],[4,6,4,7],[4,8,4,10],[7,2,7,11],[27,2,27,12],[27,14,27,15],[7,14,7,19],[27,18,27,19],[28,18,28,19],[29,18,32,19],[33,18,39,19]]}
[]
[]
[]
[]
[null,null,"Выберите неделю:",null,null,null,"Текущая неделя:",null,{"$f":"VLOOKUP(D6,Справочник!A:D,3,0)","v":"Январь неделя 1 (01-10 янв.)"},null,null,null,null,"Показатель:",15]
[null,null,null,{"$f":"for_code!B1","v":1},1,{"$f":"LEFT(I5,SEARCH(\" \",I5)-1)","v":"Январь"}]
[]
[null,null,"               Учет данных",null,null,null,null,null,null,null,null,null,"add",null,"Динамика показателей за месяц/ воронка продаж "]
[null,null,"Показатели","Директ","Adwords","Вконтакте","Поиск","Прямые","Ссылки","Instagram","…","…","Итого",null,null,{"$f":"for_code!B2","v":1},{"$f":"VLOOKUP(P9,Справочник!G:I,3,0)","v":1},{"$f":"VLOOKUP(P9,Справочник!G:J,4,0)","v":0},{"$f":"VLOOKUP(D6,Справочник!A:E,4,0)","v":1},15]
[null,null,"Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(D10:L10)","v":0},null,null,null,null,{"$f":"MAX(R11:R14)","v":{"$error":"#N/A"}}]
[null,null,"Заявки",null,null,null,null,null,null,null,null,null,0,{"$f":"Q11-$Q$9","v":2},{"$f":"LEFT($F$6,3) & \" нед1\"","v":"Янв нед1"},{"$f":"(S9-1)*4","v":0},{"$f":"2+17*P11+$Q$9","v":3},{"$f":"IF(OFFSET(БД!$K:$K,Q11-1,0,1,1)=0, NA(),OFFSET(БД!$K:$K,Q11-1,0,1,1))","v":{"$error":"#N/A"}},1]
[null,null,"Встречи",null,null,null,null,null,null,null,null,null,0,{"$f":"Q12-$Q$9","v":19},{"$f":"LEFT($F$6,3) & \" нед2\"","v":"Янв нед2"},{"$f":"P11+1","v":1},{"$f":"2+17*P12+$Q$9","v":20},{"$f":"IF(OFFSET(БД!$K:$K,Q12-1,0,1,1)=0, NA(),OFFSET(БД!$K:$K,Q12-1,0,1,1))","v":{"$error":"#N/A"}},0]
[null,null,"Продажи",null,null,null,null,null,null,null,null,null,0,36,{"$f":"LEFT($F$6,3) & \" нед3\"","v":"Янв нед3"},{"$f":"P12+1","v":2},{"$f":"2+17*P13+$Q$9","v":37},{"$f":"IF(OFFSET(БД!$K:$K,Q13-1,0,1,1)=0, NA(),OFFSET(БД!$K:$K,Q13-1,0,1,1))","v":{"$error":"#N/A"}},1]
[null,null,"Выручка",null,null,null,null,null,null,null,null,null,0,53,{"$f":"LEFT($F$6,3) & \" нед4\"","v":"Янв нед4"},3,{"$f":"2+17*P14+$Q$9","v":54},{"$f":"IF(OFFSET(БД!$K:$K,Q14-1,0,1,1)=0, NA(),OFFSET(БД!$K:$K,Q14-1,0,1,1))","v":{"$error":"#N/A"}},0]
[null,null,"Затраты",null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"CVклили-заявки",{"$f":"IF(D10>0,D11/D10,0)","v":0},{"$f":"IF(E10>0,E11/E10,0)","v":0},0,0,0,0,0,{"$f":"IF(K10>0,K11/K10,0)","v":0},0,0]
[null,null,"CVзаявки-встречи",{"$f":"IF(D11>0,D12/D11,0)","v":0},{"$f":"IF(E11>0,E12/E11,0)","v":0},0,0,0,0,0,{"$f":"IF(K11>0,K12/K11,0)","v":0},0,0]
[null,null,"CVвстречи-продажи",{"$f":"IF(D12>0,D13/D12,0)","v":0},{"$f":"IF(E12>0,E13/E12,0)","v":0},0,0,0,0,0,{"$f":"IF(K12>0,K13/K12,0)","v":0},0,0]
[null,null,"Цена клика",{"$f":"IF(D10>0,D$15/D10,0)","v":0},{"$f":"IF(E10>0,E$15/E10,0)","v":0},0,0,0,0,0,{"$f":"IF(K10>0,K$15/K10,0)","v":0},0,0]
[null,null,"Цена заявки",{"$f":"IF(D11>0,D$15/D11,0)","v":0},{"$f":"IF(E11>0,E$15/E11,0)","v":0},0,0,0,0,0,{"$f":"IF(K11>0,K$15/K11,0)","v":0},0,0]
[null,null,"Цена клиента",{"$f":"IF(D12>0,D$15/D12,0)","v":0},{"$f":"IF(E12>0,E$15/E12,0)","v":0},{"$f":"IF(F12>0,F$15/F12,0)","v":0},0,0,0,0,{"$f":"IF(K12>0,K$15/K12,0)","v":0},0,0]
[null,null,"Средний чек",{"$f":"IF(D13>0,D14/D13,0)","v":0},{"$f":"IF(E13>0,E14/E13,0)","v":0},0,0,0,0,0,{"$f":"IF(K13>0,K14/K13,0)","v":0},0,0]
[null,null,"ROI",{"$f":"IF(D15>0,(D14-D15)/D15,0)","v":0},{"$f":"IF(E15>0,(E14-E15)/E15,0)","v":0},0,0,0,0,0,{"$f":"IF(K15>0,(K14-K15)/K15,0)","v":0},0,0]
[null,null,"Прибыль (-затраты)",{"$f":"D14-D15","v":0},{"$f":"E14-E15","v":0},0,0,0,0,0,{"$f":"K14-K15","v":0},0,0]
[]
[]
[null,null,"Сводные данные за месяц",null,null,null,null,null,null,null,null,null,null,null,"Учет доп. затрат",null,null,null,"Воронка продаж 5.0 ©"]
[null,null,{"$f":"\"Всего за \" &F6","v":"Всего за Январь"},{"$f":"D9","v":"Директ"},"Adwords","Вконтакте","Поиск","Прямые","Ссылки","Instagram","…","…","Итого",null,{"$f":"\"Дополнительные затраты за \" &VLOOKUP(D6,Справочник!A:E,5,0)","v":"Дополнительные затраты за Январь"},null,null,null,"Автор: Евгений Новиков (http://vk.com/truejacko)"]
[null,null,"Клики",{"$f":"OFFSET(БД!B:B,$N$11+$V30,0,1,1)+OFFSET(БД!B:B,$N$12+$V30,0,1,1)+OFFSET(БД!B:B,$N$13+$V30,0,1,1)+OFFSET(БД!B:B,$N$14+$V30,0,1,1)","v":0},{"$f":"OFFSET(БД!C:C,$N$11+$V30,0,1,1)+OFFSET(БД!C:C,$N$12+$V30,0,1,1)+OFFSET(БД!C:C,$N$13+$V30,0,1,1)+OFFSET(БД!C:C,$N$14+$V30,0,1,1)","v":0},{"$f":"OFFSET(БД!D:D,$N$11+$V30,0,1,1)+OFFSET(БД!D:D,$N$12+$V30,0,1,1)+OFFSET(БД!D:D,$N$13+$V30,0,1,1)+OFFSET(БД!D:D,$N$14+$V30,0,1,1)","v":0},{"$f":"OFFSET(БД!E:E,$N$11+$V30,0,1,1)+OFFSET(БД!E:E,$N$12+$V30,0,1,1)+OFFSET(БД!E:E,$N$13+$V30,0,1,1)+OFFSET(БД!E:E,$N$14+$V30,0,1,1)","v":0},{"$f":"OFFSET(БД!F:F,$N$11+$V30,0,1,1)+OFFSET(БД!F:F,$N$12+$V30,0,1,1)+OFFSET(БД!F:F,$N$13+$V30,0,1,1)+OFFSET(БД!F:F,$N$14+$V30,0,1,1)","v":0},{"$f":"OFFSET(БД!G:G,$N$11+$V30,0,1,1)+OFFSET(БД!G:G,$N$12+$V30,0,1,1)+OFFSET(БД!G:G,$N$13+$V30,0,1,1)+OFFSET(БД!G:G,$N$14+$V30,0,1,1)","v":0},{"$f":"OFFSET(БД!H:H,$N$11+$V30,0,1,1)+OFFSET(БД!H:H,$N$12+$V30,0,1,1)+OFFSET(БД!H:H,$N$13+$V30,0,1,1)+OFFSET(БД!H:H,$N$14+$V30,0,1,1)","v":0},{"$f":"OFFSET(БД!H:H,$N$11+$V30,0,1,1)+OFFSET(БД!H:H,$N$12+$V30,0,1,1)+OFFSET(БД!H:H,$N$13+$V30,0,1,1)+OFFSET(БД!H:H,$N$14+$V30,0,1,1)","v":0},{"$f":"OFFSET(БД!J:J,$N$11+$V30,0,1,1)+OFFSET(БД!J:J,$N$12+$V30,0,1,1)+OFFSET(БД!J:J,$N$13+$V30,0,1,1)+OFFSET(БД!J:J,$N$14+$V30,0,1,1)","v":0},{"$f":"OFFSET(БД!K:K,$N$11+$V30,0,1,1)+OFFSET(БД!K:K,$N$12+$V30,0,1,1)+OFFSET(БД!K:K,$N$13+$V30,0,1,1)+OFFSET(БД!K:K,$N$14+$V30,0,1,1)","v":0},null,"Описание","Cумма",null,null,"Данный файл распространяется только через официальную группу vk.com/voronkaprodazh или сайт voronkaexcel.ru",null,null,0]
[null,null,"Заявки",{"$f":"OFFSET(БД!B:B,$N$11+$V31,0,1,1)+OFFSET(БД!B:B,$N$12+$V31,0,1,1)+OFFSET(БД!B:B,$N$13+$V31,0,1,1)+OFFSET(БД!B:B,$N$14+$V31,0,1,1)","v":0},{"$f":"OFFSET(БД!C:C,$N$11+$V31,0,1,1)+OFFSET(БД!C:C,$N$12+$V31,0,1,1)+OFFSET(БД!C:C,$N$13+$V31,0,1,1)+OFFSET(БД!C:C,$N$14+$V31,0,1,1)","v":0},{"$f":"OFFSET(БД!D:D,$N$11+$V31,0,1,1)+OFFSET(БД!D:D,$N$12+$V31,0,1,1)+OFFSET(БД!D:D,$N$13+$V31,0,1,1)+OFFSET(БД!D:D,$N$14+$V31,0,1,1)","v":0},{"$f":"OFFSET(БД!E:E,$N$11+$V31,0,1,1)+OFFSET(БД!E:E,$N$12+$V31,0,1,1)+OFFSET(БД!E:E,$N$13+$V31,0,1,1)+OFFSET(БД!E:E,$N$14+$V31,0,1,1)","v":0},{"$f":"OFFSET(БД!F:F,$N$11+$V31,0,1,1)+OFFSET(БД!F:F,$N$12+$V31,0,1,1)+OFFSET(БД!F:F,$N$13+$V31,0,1,1)+OFFSET(БД!F:F,$N$14+$V31,0,1,1)","v":0},{"$f":"OFFSET(БД!G:G,$N$11+$V31,0,1,1)+OFFSET(БД!G:G,$N$12+$V31,0,1,1)+OFFSET(БД!G:G,$N$13+$V31,0,1,1)+OFFSET(БД!G:G,$N$14+$V31,0,1,1)","v":0},{"$f":"OFFSET(БД!H:H,$N$11+$V31,0,1,1)+OFFSET(БД!H:H,$N$12+$V31,0,1,1)+OFFSET(БД!H:H,$N$13+$V31,0,1,1)+OFFSET(БД!H:H,$N$14+$V31,0,1,1)","v":0},{"$f":"OFFSET(БД!H:H,$N$11+$V31,0,1,1)+OFFSET(БД!H:H,$N$12+$V31,0,1,1)+OFFSET(БД!H:H,$N$13+$V31,0,1,1)+OFFSET(БД!H:H,$N$14+$V31,0,1,1)","v":0},{"$f":"OFFSET(БД!J:J,$N$11+$V31,0,1,1)+OFFSET(БД!J:J,$N$12+$V31,0,1,1)+OFFSET(БД!J:J,$N$13+$V31,0,1,1)+OFFSET(БД!J:J,$N$14+$V31,0,1,1)","v":0},{"$f":"OFFSET(БД!K:K,$N$11+$V31,0,1,1)+OFFSET(БД!K:K,$N$12+$V31,0,1,1)+OFFSET(БД!K:K,$N$13+$V31,0,1,1)+OFFSET(БД!K:K,$N$14+$V31,0,1,1)","v":0},null,null,null,null,null,null,null,null,1]
[null,null,"Встречи",{"$f":"OFFSET(БД!B:B,$N$11+$V32,0,1,1)+OFFSET(БД!B:B,$N$12+$V32,0,1,1)+OFFSET(БД!B:B,$N$13+$V32,0,1,1)+OFFSET(БД!B:B,$N$14+$V32,0,1,1)","v":0},{"$f":"OFFSET(БД!C:C,$N$11+$V32,0,1,1)+OFFSET(БД!C:C,$N$12+$V32,0,1,1)+OFFSET(БД!C:C,$N$13+$V32,0,1,1)+OFFSET(БД!C:C,$N$14+$V32,0,1,1)","v":0},{"$f":"OFFSET(БД!D:D,$N$11+$V32,0,1,1)+OFFSET(БД!D:D,$N$12+$V32,0,1,1)+OFFSET(БД!D:D,$N$13+$V32,0,1,1)+OFFSET(БД!D:D,$N$14+$V32,0,1,1)","v":0},{"$f":"OFFSET(БД!E:E,$N$11+$V32,0,1,1)+OFFSET(БД!E:E,$N$12+$V32,0,1,1)+OFFSET(БД!E:E,$N$13+$V32,0,1,1)+OFFSET(БД!E:E,$N$14+$V32,0,1,1)","v":0},{"$f":"OFFSET(БД!F:F,$N$11+$V32,0,1,1)+OFFSET(БД!F:F,$N$12+$V32,0,1,1)+OFFSET(БД!F:F,$N$13+$V32,0,1,1)+OFFSET(БД!F:F,$N$14+$V32,0,1,1)","v":0},{"$f":"OFFSET(БД!G:G,$N$11+$V32,0,1,1)+OFFSET(БД!G:G,$N$12+$V32,0,1,1)+OFFSET(БД!G:G,$N$13+$V32,0,1,1)+OFFSET(БД!G:G,$N$14+$V32,0,1,1)","v":0},{"$f":"OFFSET(БД!H:H,$N$11+$V32,0,1,1)+OFFSET(БД!H:H,$N$12+$V32,0,1,1)+OFFSET(БД!H:H,$N$13+$V32,0,1,1)+OFFSET(БД!H:H,$N$14+$V32,0,1,1)","v":0},{"$f":"OFFSET(БД!H:H,$N$11+$V32,0,1,1)+OFFSET(БД!H:H,$N$12+$V32,0,1,1)+OFFSET(БД!H:H,$N$13+$V32,0,1,1)+OFFSET(БД!H:H,$N$14+$V32,0,1,1)","v":0},{"$f":"OFFSET(БД!J:J,$N$11+$V32,0,1,1)+OFFSET(БД!J:J,$N$12+$V32,0,1,1)+OFFSET(БД!J:J,$N$13+$V32,0,1,1)+OFFSET(БД!J:J,$N$14+$V32,0,1,1)","v":0},{"$f":"OFFSET(БД!K:K,$N$11+$V32,0,1,1)+OFFSET(БД!K:K,$N$12+$V32,0,1,1)+OFFSET(БД!K:K,$N$13+$V32,0,1,1)+OFFSET(БД!K:K,$N$14+$V32,0,1,1)","v":0},null,null,null,null,null,null,null,null,2]
[null,null,"Продажи",{"$f":"OFFSET(БД!B:B,$N$11+$V33,0,1,1)+OFFSET(БД!B:B,$N$12+$V33,0,1,1)+OFFSET(БД!B:B,$N$13+$V33,0,1,1)+OFFSET(БД!B:B,$N$14+$V33,0,1,1)","v":0},{"$f":"OFFSET(БД!C:C,$N$11+$V33,0,1,1)+OFFSET(БД!C:C,$N$12+$V33,0,1,1)+OFFSET(БД!C:C,$N$13+$V33,0,1,1)+OFFSET(БД!C:C,$N$14+$V33,0,1,1)","v":0},{"$f":"OFFSET(БД!D:D,$N$11+$V33,0,1,1)+OFFSET(БД!D:D,$N$12+$V33,0,1,1)+OFFSET(БД!D:D,$N$13+$V33,0,1,1)+OFFSET(БД!D:D,$N$14+$V33,0,1,1)","v":0},{"$f":"OFFSET(БД!E:E,$N$11+$V33,0,1,1)+OFFSET(БД!E:E,$N$12+$V33,0,1,1)+OFFSET(БД!E:E,$N$13+$V33,0,1,1)+OFFSET(БД!E:E,$N$14+$V33,0,1,1)","v":0},{"$f":"OFFSET(БД!F:F,$N$11+$V33,0,1,1)+OFFSET(БД!F:F,$N$12+$V33,0,1,1)+OFFSET(БД!F:F,$N$13+$V33,0,1,1)+OFFSET(БД!F:F,$N$14+$V33,0,1,1)","v":0},{"$f":"OFFSET(БД!G:G,$N$11+$V33,0,1,1)+OFFSET(БД!G:G,$N$12+$V33,0,1,1)+OFFSET(БД!G:G,$N$13+$V33,0,1,1)+OFFSET(БД!G:G,$N$14+$V33,0,1,1)","v":0},{"$f":"OFFSET(БД!H:H,$N$11+$V33,0,1,1)+OFFSET(БД!H:H,$N$12+$V33,0,1,1)+OFFSET(БД!H:H,$N$13+$V33,0,1,1)+OFFSET(БД!H:H,$N$14+$V33,0,1,1)","v":0},{"$f":"OFFSET(БД!H:H,$N$11+$V33,0,1,1)+OFFSET(БД!H:H,$N$12+$V33,0,1,1)+OFFSET(БД!H:H,$N$13+$V33,0,1,1)+OFFSET(БД!H:H,$N$14+$V33,0,1,1)","v":0},{"$f":"OFFSET(БД!J:J,$N$11+$V33,0,1,1)+OFFSET(БД!J:J,$N$12+$V33,0,1,1)+OFFSET(БД!J:J,$N$13+$V33,0,1,1)+OFFSET(БД!J:J,$N$14+$V33,0,1,1)","v":0},{"$f":"OFFSET(БД!K:K,$N$11+$V33,0,1,1)+OFFSET(БД!K:K,$N$12+$V33,0,1,1)+OFFSET(БД!K:K,$N$13+$V33,0,1,1)+OFFSET(БД!K:K,$N$14+$V33,0,1,1)","v":0},null,null,null,null,null,null,null,null,3]
[null,null,"Выручка",{"$f":"OFFSET(БД!B:B,$N$11+$V34,0,1,1)+OFFSET(БД!B:B,$N$12+$V34,0,1,1)+OFFSET(БД!B:B,$N$13+$V34,0,1,1)+OFFSET(БД!B:B,$N$14+$V34,0,1,1)","v":0},{"$f":"OFFSET(БД!C:C,$N$11+$V34,0,1,1)+OFFSET(БД!C:C,$N$12+$V34,0,1,1)+OFFSET(БД!C:C,$N$13+$V34,0,1,1)+OFFSET(БД!C:C,$N$14+$V34,0,1,1)","v":0},{"$f":"OFFSET(БД!D:D,$N$11+$V34,0,1,1)+OFFSET(БД!D:D,$N$12+$V34,0,1,1)+OFFSET(БД!D:D,$N$13+$V34,0,1,1)+OFFSET(БД!D:D,$N$14+$V34,0,1,1)","v":0},{"$f":"OFFSET(БД!E:E,$N$11+$V34,0,1,1)+OFFSET(БД!E:E,$N$12+$V34,0,1,1)+OFFSET(БД!E:E,$N$13+$V34,0,1,1)+OFFSET(БД!E:E,$N$14+$V34,0,1,1)","v":0},{"$f":"OFFSET(БД!F:F,$N$11+$V34,0,1,1)+OFFSET(БД!F:F,$N$12+$V34,0,1,1)+OFFSET(БД!F:F,$N$13+$V34,0,1,1)+OFFSET(БД!F:F,$N$14+$V34,0,1,1)","v":0},{"$f":"OFFSET(БД!G:G,$N$11+$V34,0,1,1)+OFFSET(БД!G:G,$N$12+$V34,0,1,1)+OFFSET(БД!G:G,$N$13+$V34,0,1,1)+OFFSET(БД!G:G,$N$14+$V34,0,1,1)","v":0},{"$f":"OFFSET(БД!H:H,$N$11+$V34,0,1,1)+OFFSET(БД!H:H,$N$12+$V34,0,1,1)+OFFSET(БД!H:H,$N$13+$V34,0,1,1)+OFFSET(БД!H:H,$N$14+$V34,0,1,1)","v":0},{"$f":"OFFSET(БД!H:H,$N$11+$V34,0,1,1)+OFFSET(БД!H:H,$N$12+$V34,0,1,1)+OFFSET(БД!H:H,$N$13+$V34,0,1,1)+OFFSET(БД!H:H,$N$14+$V34,0,1,1)","v":0},{"$f":"OFFSET(БД!J:J,$N$11+$V34,0,1,1)+OFFSET(БД!J:J,$N$12+$V34,0,1,1)+OFFSET(БД!J:J,$N$13+$V34,0,1,1)+OFFSET(БД!J:J,$N$14+$V34,0,1,1)","v":0},{"$f":"OFFSET(БД!K:K,$N$11+$V34,0,1,1)+OFFSET(БД!K:K,$N$12+$V34,0,1,1)+OFFSET(БД!K:K,$N$13+$V34,0,1,1)+OFFSET(БД!K:K,$N$14+$V34,0,1,1)","v":0},null,null,null,null,null,"Если вы оказались жертвой пиратов, прошу вас перечислить удобную сумму в качестве благодарности за данный продукт автору: яндекс 410011194833509 Webmoney: R304185449904, Z627412013302 QIWI: +79851745518"]
[null,null,"затраты",{"$f":"OFFSET(БД!B:B,$N$11+$V35,0,1,1)+OFFSET(БД!B:B,$N$12+$V35,0,1,1)+OFFSET(БД!B:B,$N$13+$V35,0,1,1)+OFFSET(БД!B:B,$N$14+$V35,0,1,1)","v":0},{"$f":"OFFSET(БД!C:C,$N$11+$V35,0,1,1)+OFFSET(БД!C:C,$N$12+$V35,0,1,1)+OFFSET(БД!C:C,$N$13+$V35,0,1,1)+OFFSET(БД!C:C,$N$14+$V35,0,1,1)","v":0},{"$f":"OFFSET(БД!D:D,$N$11+$V35,0,1,1)+OFFSET(БД!D:D,$N$12+$V35,0,1,1)+OFFSET(БД!D:D,$N$13+$V35,0,1,1)+OFFSET(БД!D:D,$N$14+$V35,0,1,1)","v":0},{"$f":"OFFSET(БД!E:E,$N$11+$V35,0,1,1)+OFFSET(БД!E:E,$N$12+$V35,0,1,1)+OFFSET(БД!E:E,$N$13+$V35,0,1,1)+OFFSET(БД!E:E,$N$14+$V35,0,1,1)","v":0},{"$f":"OFFSET(БД!F:F,$N$11+$V35,0,1,1)+OFFSET(БД!F:F,$N$12+$V35,0,1,1)+OFFSET(БД!F:F,$N$13+$V35,0,1,1)+OFFSET(БД!F:F,$N$14+$V35,0,1,1)","v":0},{"$f":"OFFSET(БД!G:G,$N$11+$V35,0,1,1)+OFFSET(БД!G:G,$N$12+$V35,0,1,1)+OFFSET(БД!G:G,$N$13+$V35,0,1,1)+OFFSET(БД!G:G,$N$14+$V35,0,1,1)","v":0},{"$f":"OFFSET(БД!H:H,$N$11+$V35,0,1,1)+OFFSET(БД!H:H,$N$12+$V35,0,1,1)+OFFSET(БД!H:H,$N$13+$V35,0,1,1)+OFFSET(БД!H:H,$N$14+$V35,0,1,1)","v":0},{"$f":"OFFSET(БД!H:H,$N$11+$V35,0,1,1)+OFFSET(БД!H:H,$N$12+$V35,0,1,1)+OFFSET(БД!H:H,$N$13+$V35,0,1,1)+OFFSET(БД!H:H,$N$14+$V35,0,1,1)","v":0},{"$f":"OFFSET(БД!J:J,$N$11+$V35,0,1,1)+OFFSET(БД!J:J,$N$12+$V35,0,1,1)+OFFSET(БД!J:J,$N$13+$V35,0,1,1)+OFFSET(БД!J:J,$N$14+$V35,0,1,1)","v":0},{"$f":"OFFSET(БД!K:K,$N$11+$V35,0,1,1)+OFFSET(БД!K:K,$N$12+$V35,0,1,1)+OFFSET(БД!K:K,$N$13+$V35,0,1,1)+OFFSET(БД!K:K,$N$14+$V35,0,1,1)","v":0},null,null,null,null,null,null,null,null,5]
[]
[null,null,"CVклики-заявки",{"$f":"IF(D30>0,D31/D30,0)","v":0},{"$f":"IF(E30>0,E31/E30,0)","v":0},0,0,0,0,0,{"$f":"IF(K30>0,K31/K30,0)","v":0},0,0,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(C30,\" \", M30)","v":"Клики 0"},{"$f":"CONCATENATE(X37,\" \", ROUND(M37*100,2)&\"%\")","v":"CVкл-зая 0%"},"CVкл-зая"]
[null,null,"CVзаявки-встречи",{"$f":"IF(D31>0,D32/D31,0)","v":0},{"$f":"IF(E31>0,E32/E31,0)","v":0},0,0,0,0,0,{"$f":"IF(K31>0,K32/K31,0)","v":0},0,0,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(C31,\" \", M31)","v":"Заявки 0"},{"$f":"CONCATENATE(X38,\" \", ROUND(M38*100,2)&\"%\")","v":"CVзая-встр 0%"},"CVзая-встр"]
[null,null,"CVвстречи-продажи",{"$f":"IF(D32>0,D33/D32,0)","v":0},{"$f":"IF(E32>0,E33/E32,0)","v":0},0,0,0,0,0,{"$f":"IF(K32>0,K33/K32,0)","v":0},0,0,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(C32,\" \", M32)","v":"Встречи 0"},{"$f":"CONCATENATE(X39,\" \", ROUND(M39*100,2)&\"%\")","v":"CVвстр-прод 0%"},"CVвстр-прод"]
[null,null,"Цена клика",{"$f":"IF(D30>0,D$35/D30,0)","v":0},{"$f":"IF(E30>0,E$35/E30,0)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(C33,\" \", M33)","v":"Продажи 0"}]
[null,null,"Цена заявки",{"$f":"IF(D31>0,D$35/D31,0)","v":0},{"$f":"IF(E31>0,E$35/E31,0)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,"Вы можете заказать индивидуальную таблицу или доработки текущей, обратившись на мейл info@kursdirect.ru",null,null,{"$f":"CONCATENATE(C34,\" \n\",TEXT(M34,\"#\\ ##0р.\"))","v":"Выручка \n 0р."},"\n"]
[null,null,"Цена клиента",{"$f":"IF(D32>0,D$35/D32,0)","v":0},{"$f":"IF(E32>0,E$35/E32,0)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(C35,\" \", M35)","v":"затраты 0"}]
[null,null,"Средн чек",{"$f":"IF(D33>0,D34/D33,0)","v":0},{"$f":"IF(E33>0,E34/E33,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,"ROI",{"$f":"IF(D35>0,(D34-D35)/D35,0)","v":0},{"$f":"IF(E35>0,(E34-E35)/E35,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Прибыль (-затраты)",{"$f":"D34-D35","v":0},{"$f":"E34-E35","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,"Закажите скайп-консультацию по ведению воронки от автора (цена 1500р). Пишите на мейл или ВК."]
[null,null,"Чистая прибыль (-доп)",{"$f":"M45-J46","v":0},null,null,null,"Дополнит. затраты",null,{"$f":"P46","v":0},null,null,null,null,"Итого:",{"$f":"SUM(P31:P45)","v":0}]

{"sheet":"Статистика","index":1,"n_rows":58,"n_cols":108,"rows_kept":58,"cut":false,"hidden":false,"merged":[[12,3,12,50],[1,21,1,26],[43,2,43,3],[54,19,54,20],[54,36,54,37],[21,36,21,37],[22,36,22,37],[33,36,33,37],[33,19,33,20],[33,2,33,3],[32,36,32,37],[32,19,32,20],[32,2,32,3],[21,2,21,3],[22,2,22,3],[55,36,55,37],[54,2,54,3],[43,19,43,20],[43,36,43,37],[55,2,55,3],[44,19,44,20],[44,36,44,37],[57,2,57,3],[56,1,56,3],[21,19,21,20],[22,19,22,20],[44,2,44,3],[55,19,55,20]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,4,6,8,10,12,14,16,18,20,22,24,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Показатели","январь","февраль","март","апрель","май","июнь","июль","август","сентябрь","октябрь","ноябрь","декабрь",{"$f":"VLOOKUP(CJ1,Справочник!M:N,2,0)","v":"Январь"},null,null,null,null,null,null,null,null,"январь","февраль","март","апрель","май","июнь","июль","август","сентябрь","октябрь","ноябрь","декабрь"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Клики",{"$f":"IF((OFFSET(БД!$K:$K,CS$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CS$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CS$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CS$10+$CR3-1,0,1,1))>0,OFFSET(БД!$K:$K,CS$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CS$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CS$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CS$10+$CR3-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CT$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CT$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CT$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CT$10+$CR3-1,0,1,1))>0,OFFSET(БД!$K:$K,CT$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CT$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CT$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CT$10+$CR3-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CU$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CU$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CU$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CU$10+$CR3-1,0,1,1))>0,OFFSET(БД!$K:$K,CU$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CU$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CU$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CU$10+$CR3-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CV$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CV$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CV$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CV$10+$CR3-1,0,1,1))>0,OFFSET(БД!$K:$K,CV$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CV$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CV$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CV$10+$CR3-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CW$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CW$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CW$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CW$10+$CR3-1,0,1,1))>0,OFFSET(БД!$K:$K,CW$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CW$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CW$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CW$10+$CR3-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CX$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CX$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CX$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CX$10+$CR3-1,0,1,1))>0,OFFSET(БД!$K:$K,CX$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CX$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CX$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CX$10+$CR3-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CY$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CY$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CY$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CY$10+$CR3-1,0,1,1))>0,OFFSET(БД!$K:$K,CY$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CY$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CY$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CY$10+$CR3-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CZ$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CZ$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CZ$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CZ$10+$CR3-1,0,1,1))>0,OFFSET(БД!$K:$K,CZ$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CZ$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CZ$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,CZ$10+$CR3-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DA$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DA$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DA$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DA$10+$CR3-1,0,1,1))>0,OFFSET(БД!$K:$K,DA$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DA$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DA$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DA$10+$CR3-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DB$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DB$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DB$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DB$10+$CR3-1,0,1,1))>0,OFFSET(БД!$K:$K,DB$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DB$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DB$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DB$10+$CR3-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DC$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DC$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DC$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DC$10+$CR3-1,0,1,1))>0,OFFSET(БД!$K:$K,DC$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DC$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DC$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DC$10+$CR3-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DD$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DD$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DD$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DD$10+$CR3-1,0,1,1))>0,OFFSET(БД!$K:$K,DD$7+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DD$8+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DD$9+$CR3-1,0,1,1)+OFFSET(БД!$K:$K,DD$10+$CR3-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ABS(OFFSET($BW3,,$CJ$1,1,1))>=10000,ROUND(OFFSET($BW3,,$CJ$1,1,1)/1000,1)&\"т\",OFFSET($BW3,,$CJ$1,1,1))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,0,0,{"$f":"CS6+1","v":4},{"$f":"CT6+1","v":8},12,16,20,24,28,32,36,40,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заявки",{"$f":"IF((OFFSET(БД!$K:$K,CS$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CS$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CS$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CS$10+$CR4-1,0,1,1))>0,OFFSET(БД!$K:$K,CS$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CS$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CS$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CS$10+$CR4-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CT$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CT$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CT$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CT$10+$CR4-1,0,1,1))>0,OFFSET(БД!$K:$K,CT$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CT$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CT$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CT$10+$CR4-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CU$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CU$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CU$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CU$10+$CR4-1,0,1,1))>0,OFFSET(БД!$K:$K,CU$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CU$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CU$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CU$10+$CR4-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CV$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CV$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CV$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CV$10+$CR4-1,0,1,1))>0,OFFSET(БД!$K:$K,CV$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CV$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CV$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CV$10+$CR4-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CW$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CW$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CW$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CW$10+$CR4-1,0,1,1))>0,OFFSET(БД!$K:$K,CW$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CW$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CW$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CW$10+$CR4-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CX$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CX$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CX$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CX$10+$CR4-1,0,1,1))>0,OFFSET(БД!$K:$K,CX$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CX$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CX$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CX$10+$CR4-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CY$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CY$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CY$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CY$10+$CR4-1,0,1,1))>0,OFFSET(БД!$K:$K,CY$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CY$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CY$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CY$10+$CR4-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CZ$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CZ$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CZ$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CZ$10+$CR4-1,0,1,1))>0,OFFSET(БД!$K:$K,CZ$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CZ$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CZ$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,CZ$10+$CR4-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DA$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DA$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DA$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DA$10+$CR4-1,0,1,1))>0,OFFSET(БД!$K:$K,DA$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DA$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DA$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DA$10+$CR4-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DB$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DB$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DB$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DB$10+$CR4-1,0,1,1))>0,OFFSET(БД!$K:$K,DB$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DB$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DB$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DB$10+$CR4-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DC$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DC$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DC$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DC$10+$CR4-1,0,1,1))>0,OFFSET(БД!$K:$K,DC$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DC$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DC$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DC$10+$CR4-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DD$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DD$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DD$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DD$10+$CR4-1,0,1,1))>0,OFFSET(БД!$K:$K,DD$7+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DD$8+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DD$9+$CR4-1,0,1,1)+OFFSET(БД!$K:$K,DD$10+$CR4-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ABS(OFFSET($BW4,,$CJ$1,1,1))>=1000,ROUND(OFFSET($BW4,,$CJ$1,1,1)/1000,1)&\"т\",OFFSET($BW4,,$CJ$1,1,1))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,1,1,{"$f":"CT3+1","v":5},{"$f":"CU3+1","v":9},13,17,21,25,29,33,37,41,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Встречи",{"$f":"IF((OFFSET(БД!$K:$K,CS$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CS$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CS$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CS$10+$CR5-1,0,1,1))>0,OFFSET(БД!$K:$K,CS$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CS$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CS$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CS$10+$CR5-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CT$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CT$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CT$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CT$10+$CR5-1,0,1,1))>0,OFFSET(БД!$K:$K,CT$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CT$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CT$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CT$10+$CR5-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CU$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CU$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CU$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CU$10+$CR5-1,0,1,1))>0,OFFSET(БД!$K:$K,CU$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CU$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CU$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CU$10+$CR5-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CV$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CV$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CV$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CV$10+$CR5-1,0,1,1))>0,OFFSET(БД!$K:$K,CV$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CV$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CV$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CV$10+$CR5-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CW$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CW$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CW$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CW$10+$CR5-1,0,1,1))>0,OFFSET(БД!$K:$K,CW$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CW$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CW$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CW$10+$CR5-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CX$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CX$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CX$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CX$10+$CR5-1,0,1,1))>0,OFFSET(БД!$K:$K,CX$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CX$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CX$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CX$10+$CR5-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CY$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CY$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CY$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CY$10+$CR5-1,0,1,1))>0,OFFSET(БД!$K:$K,CY$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CY$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CY$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CY$10+$CR5-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CZ$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CZ$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CZ$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CZ$10+$CR5-1,0,1,1))>0,OFFSET(БД!$K:$K,CZ$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CZ$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CZ$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,CZ$10+$CR5-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DA$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DA$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DA$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DA$10+$CR5-1,0,1,1))>0,OFFSET(БД!$K:$K,DA$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DA$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DA$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DA$10+$CR5-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DB$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DB$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DB$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DB$10+$CR5-1,0,1,1))>0,OFFSET(БД!$K:$K,DB$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DB$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DB$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DB$10+$CR5-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DC$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DC$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DC$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DC$10+$CR5-1,0,1,1))>0,OFFSET(БД!$K:$K,DC$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DC$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DC$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DC$10+$CR5-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DD$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DD$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DD$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DD$10+$CR5-1,0,1,1))>0,OFFSET(БД!$K:$K,DD$7+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DD$8+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DD$9+$CR5-1,0,1,1)+OFFSET(БД!$K:$K,DD$10+$CR5-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ABS(OFFSET($BW5,,$CJ$1,1,1))>=1000,ROUND(OFFSET($BW5,,$CJ$1,1,1)/1000,1)&\"т\",OFFSET($BW5,,$CJ$1,1,1))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,2,2,{"$f":"CT4+1","v":6},10,14,18,22,26,30,34,38,42,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Продажи",{"$f":"IF((OFFSET(БД!$K:$K,CS$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CS$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CS$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CS$10+$CR6-1,0,1,1))>0,OFFSET(БД!$K:$K,CS$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CS$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CS$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CS$10+$CR6-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CT$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CT$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CT$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CT$10+$CR6-1,0,1,1))>0,OFFSET(БД!$K:$K,CT$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CT$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CT$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CT$10+$CR6-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CU$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CU$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CU$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CU$10+$CR6-1,0,1,1))>0,OFFSET(БД!$K:$K,CU$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CU$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CU$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CU$10+$CR6-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CV$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CV$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CV$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CV$10+$CR6-1,0,1,1))>0,OFFSET(БД!$K:$K,CV$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CV$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CV$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CV$10+$CR6-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CW$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CW$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CW$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CW$10+$CR6-1,0,1,1))>0,OFFSET(БД!$K:$K,CW$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CW$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CW$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CW$10+$CR6-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CX$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CX$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CX$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CX$10+$CR6-1,0,1,1))>0,OFFSET(БД!$K:$K,CX$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CX$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CX$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CX$10+$CR6-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CY$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CY$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CY$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CY$10+$CR6-1,0,1,1))>0,OFFSET(БД!$K:$K,CY$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CY$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CY$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CY$10+$CR6-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CZ$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CZ$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CZ$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CZ$10+$CR6-1,0,1,1))>0,OFFSET(БД!$K:$K,CZ$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CZ$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CZ$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,CZ$10+$CR6-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DA$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DA$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DA$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DA$10+$CR6-1,0,1,1))>0,OFFSET(БД!$K:$K,DA$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DA$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DA$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DA$10+$CR6-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DB$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DB$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DB$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DB$10+$CR6-1,0,1,1))>0,OFFSET(БД!$K:$K,DB$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DB$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DB$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DB$10+$CR6-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DC$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DC$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DC$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DC$10+$CR6-1,0,1,1))>0,OFFSET(БД!$K:$K,DC$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DC$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DC$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DC$10+$CR6-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DD$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DD$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DD$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DD$10+$CR6-1,0,1,1))>0,OFFSET(БД!$K:$K,DD$7+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DD$8+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DD$9+$CR6-1,0,1,1)+OFFSET(БД!$K:$K,DD$10+$CR6-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ABS(OFFSET($BW6,,$CJ$1,1,1))>=1000,ROUND(OFFSET($BW6,,$CJ$1,1,1)/1000,1)&\"т\",OFFSET($BW6,,$CJ$1,1,1))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,3,3,7,11,15,19,23,27,31,35,39,43,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Выручка",{"$f":"IF((OFFSET(БД!$K:$K,CS$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CS$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CS$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CS$10+$CR7-1,0,1,1))>0,OFFSET(БД!$K:$K,CS$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CS$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CS$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CS$10+$CR7-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CT$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CT$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CT$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CT$10+$CR7-1,0,1,1))>0,OFFSET(БД!$K:$K,CT$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CT$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CT$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CT$10+$CR7-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CU$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CU$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CU$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CU$10+$CR7-1,0,1,1))>0,OFFSET(БД!$K:$K,CU$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CU$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CU$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CU$10+$CR7-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CV$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CV$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CV$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CV$10+$CR7-1,0,1,1))>0,OFFSET(БД!$K:$K,CV$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CV$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CV$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CV$10+$CR7-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CW$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CW$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CW$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CW$10+$CR7-1,0,1,1))>0,OFFSET(БД!$K:$K,CW$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CW$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CW$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CW$10+$CR7-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CX$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CX$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CX$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CX$10+$CR7-1,0,1,1))>0,OFFSET(БД!$K:$K,CX$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CX$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CX$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CX$10+$CR7-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CY$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CY$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CY$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CY$10+$CR7-1,0,1,1))>0,OFFSET(БД!$K:$K,CY$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CY$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CY$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CY$10+$CR7-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CZ$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CZ$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CZ$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CZ$10+$CR7-1,0,1,1))>0,OFFSET(БД!$K:$K,CZ$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CZ$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CZ$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,CZ$10+$CR7-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DA$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DA$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DA$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DA$10+$CR7-1,0,1,1))>0,OFFSET(БД!$K:$K,DA$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DA$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DA$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DA$10+$CR7-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DB$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DB$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DB$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DB$10+$CR7-1,0,1,1))>0,OFFSET(БД!$K:$K,DB$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DB$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DB$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DB$10+$CR7-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DC$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DC$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DC$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DC$10+$CR7-1,0,1,1))>0,OFFSET(БД!$K:$K,DC$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DC$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DC$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DC$10+$CR7-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DD$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DD$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DD$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DD$10+$CR7-1,0,1,1))>0,OFFSET(БД!$K:$K,DD$7+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DD$8+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DD$9+$CR7-1,0,1,1)+OFFSET(БД!$K:$K,DD$10+$CR7-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ABS(OFFSET($BW7,,$CJ$1,1,1))>=1000,ROUND(OFFSET($BW7,,$CJ$1,1,1)/1000,1)&\" т. р.\",OFFSET($BW7,,$CJ$1,1,1))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,4,{"$f":"2+17*CS3+1","v":3},{"$f":"2+17*CT3+1","v":71},139,207,275,343,411,479,547,615,683,751]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Реклама",{"$f":"IF((OFFSET(БД!$K:$K,CS$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CS$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CS$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CS$10+$CR8-1,0,1,1))>0,OFFSET(БД!$K:$K,CS$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CS$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CS$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CS$10+$CR8-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CT$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CT$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CT$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CT$10+$CR8-1,0,1,1))>0,OFFSET(БД!$K:$K,CT$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CT$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CT$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CT$10+$CR8-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CU$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CU$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CU$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CU$10+$CR8-1,0,1,1))>0,OFFSET(БД!$K:$K,CU$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CU$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CU$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CU$10+$CR8-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CV$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CV$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CV$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CV$10+$CR8-1,0,1,1))>0,OFFSET(БД!$K:$K,CV$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CV$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CV$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CV$10+$CR8-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CW$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CW$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CW$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CW$10+$CR8-1,0,1,1))>0,OFFSET(БД!$K:$K,CW$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CW$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CW$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CW$10+$CR8-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CX$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CX$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CX$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CX$10+$CR8-1,0,1,1))>0,OFFSET(БД!$K:$K,CX$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CX$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CX$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CX$10+$CR8-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CY$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CY$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CY$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CY$10+$CR8-1,0,1,1))>0,OFFSET(БД!$K:$K,CY$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CY$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CY$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CY$10+$CR8-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,CZ$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CZ$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CZ$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CZ$10+$CR8-1,0,1,1))>0,OFFSET(БД!$K:$K,CZ$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CZ$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CZ$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,CZ$10+$CR8-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DA$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DA$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DA$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DA$10+$CR8-1,0,1,1))>0,OFFSET(БД!$K:$K,DA$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DA$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DA$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DA$10+$CR8-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DB$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DB$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DB$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DB$10+$CR8-1,0,1,1))>0,OFFSET(БД!$K:$K,DB$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DB$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DB$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DB$10+$CR8-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DC$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DC$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DC$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DC$10+$CR8-1,0,1,1))>0,OFFSET(БД!$K:$K,DC$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DC$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DC$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DC$10+$CR8-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF((OFFSET(БД!$K:$K,DD$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DD$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DD$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DD$10+$CR8-1,0,1,1))>0,OFFSET(БД!$K:$K,DD$7+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DD$8+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DD$9+$CR8-1,0,1,1)+OFFSET(БД!$K:$K,DD$10+$CR8-1,0,1,1),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ABS(OFFSET($BW8,,$CJ$1,1,1))>=1000,ROUND(OFFSET($BW8,,$CJ$1,1,1)/1000,1)&\" т. р.\",OFFSET($BW8,,$CJ$1,1,1))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,5,{"$f":"2+17*CS4+1","v":20},88,156,224,292,360,428,496,564,632,700,768]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Прочие затраты",{"$f":"IF(SUM(OFFSET(БД!$N:$N,,BX$1))>0,SUM(OFFSET(БД!$N:$N,,BX$1)),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SUM(OFFSET(БД!$N:$N,,BY$1))>0,SUM(OFFSET(БД!$N:$N,,BY$1)),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SUM(OFFSET(БД!$N:$N,,BZ$1))>0,SUM(OFFSET(БД!$N:$N,,BZ$1)),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SUM(OFFSET(БД!$N:$N,,CA$1))>0,SUM(OFFSET(БД!$N:$N,,CA$1)),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SUM(OFFSET(БД!$N:$N,,CB$1))>0,SUM(OFFSET(БД!$N:$N,,CB$1)),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SUM(OFFSET(БД!$N:$N,,CC$1))>0,SUM(OFFSET(БД!$N:$N,,CC$1)),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SUM(OFFSET(БД!$N:$N,,CD$1))>0,SUM(OFFSET(БД!$N:$N,,CD$1)),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SUM(OFFSET(БД!$N:$N,,CE$1))>0,SUM(OFFSET(БД!$N:$N,,CE$1)),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SUM(OFFSET(БД!$N:$N,,CF$1))>0,SUM(OFFSET(БД!$N:$N,,CF$1)),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SUM(OFFSET(БД!$N:$N,,CG$1))>0,SUM(OFFSET(БД!$N:$N,,CG$1)),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SUM(OFFSET(БД!$N:$N,,CH$1))>0,SUM(OFFSET(БД!$N:$N,,CH$1)),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SUM(OFFSET(БД!$N:$N,,CI$1))>0,SUM(OFFSET(БД!$N:$N,,CI$1)),NA())","v":{"$error":"#N/A"}},{"$f":"IF(ABS(OFFSET($BW9,,$CJ$1,1,1))>=1000,ROUND(OFFSET($BW9,,$CJ$1,1,1)/1000,1)&\" т. р.\",OFFSET($BW9,,$CJ$1,1,1))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,37,105,173,241,309,377,445,513,581,649,717,785]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CVкл-заявки",{"$f":"IF(BX3>0,BX4/BX3,NA())","v":{"$error":"#N/A"}},{"$f":"IF(BY3>0,BY4/BY3,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"OFFSET($BW10,,$CJ$1,1,1)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,54,122,190,258,326,394,462,530,598,666,734,802]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CVзаяв-встр",{"$f":"IF(BX4>0,BX5/BX4,NA())","v":{"$error":"#N/A"}},{"$f":"IF(BY4>0,BY5/BY4,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"OFFSET($BW11,,$CJ$1,1,1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CVвстр-пр",{"$f":"IF(BX5>0,BX6/BX5,NA())","v":{"$error":"#N/A"}},{"$f":"IF(BY5>0,BY6/BY5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"OFFSET($BW12,,$CJ$1,1,1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Цена клика",{"$f":"IF(BX3>0,BX8/BX3,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(ABS(OFFSET($BW13,,$CJ$1,1,1))>=1000,ROUND(OFFSET($BW13,,$CJ$1,1,1)/1000,1)&\" т. р.\",OFFSET($BW13,,$CJ$1,1,1))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Цена заявки",{"$f":"IF(BX4>0,BX8/BX4,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(ABS(OFFSET($BW14,,$CJ$1,1,1))>=1000,ROUND(OFFSET($BW14,,$CJ$1,1,1)/1000,1)&\" т. р.\",OFFSET($BW14,,$CJ$1,1,1))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Цена клиента",{"$f":"IF(BX5>0,BX8/BX5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(ABS(OFFSET($BW15,,$CJ$1,1,1))>=1000,ROUND(OFFSET($BW15,,$CJ$1,1,1)/1000,1)&\" т. р.\",OFFSET($BW15,,$CJ$1,1,1))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Средн чек",{"$f":"IF(BX6>0,BX7/BX6,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(ABS(OFFSET($BW16,,$CJ$1,1,1))>=1000,ROUND(OFFSET($BW16,,$CJ$1,1,1)/1000,1)&\" т. р.\",OFFSET($BW16,,$CJ$1,1,1))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROI",{"$f":"IF(BX8>0,(BX7-BX8)/BX8,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"OFFSET($BW17,,$CJ$1,1,1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"прибыль (-затраты)",{"$f":"IF((BX7-BX8)<>0,BX7-BX8,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(ABS(OFFSET($BW18,,$CJ$1,1,1))>=1000,ROUND(OFFSET($BW18,,$CJ$1,1,1)/1000,1)&\" т. р.\",OFFSET($BW18,,$CJ$1,1,1))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Чистая прибыль",{"$f":"IF((BX18-IFERROR(BX9,0))<>0,BX18-IFERROR(BX9,0),NA())","v":{"$error":"#N/A"}},{"$f":"IF((BY18-IFERROR(BY9,0))<>0,BY18-IFERROR(BY9,0),NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(ABS(OFFSET($BW19,,$CJ$1,1,1))>=1000,ROUND(OFFSET($BW19,,$CJ$1,1,1)/1000,1)&\" т. р.\",OFFSET($BW19,,$CJ$1,1,1))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,1,0,1,0,1,0,1,0,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"янв","фев","мар","апр","май","июн","июл","авг","сен","окт","ноя","дек"]
[null,null,"Значение",null,{"$f":"IF(ABS(BX19)>=1000,ROUND(BX19/1000,1)&\"т. р.\",BX19)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"Значение",null,{"$f":"BX10","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"Значение",null,{"$f":"IF(ABS(BX3)>=1000,ROUND(BX3/1000,1)&\"k\",BX3)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,"Динамика",null,"х",{"$f":"IFERROR((BY19-BX19)/BX19,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,"Динамика",null,"х",{"$f":"IFERROR((BY10-BX10)/BX10,0)","v":0},{"$f":"IFERROR((BZ10-BY10)/BY10,0)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,"Динамика",null,"х",{"$f":"IFERROR((BY3-BX3)/BX3,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Клики",{"$f":"IF(BX$22=$CJ$1,BX3,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заявки",{"$f":"IF(BX$22=$CJ$1,BX4,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Встречи",{"$f":"IF(BX$22=$CJ$1,BX5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Продажи",{"$f":"IF(BX$22=$CJ$1,BX6,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Выручка",{"$f":"IF(BX$22=$CJ$1,BX7,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Реклама",{"$f":"IF(BX$22=$CJ$1,BX40,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Прочие затраты",{"$f":"IF(BX$22=$CJ$1,BX41,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CVкл-заявки",{"$f":"IF(BX$22=$CJ$1,BX10,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CVзаяв-встр",{"$f":"IF(BX$22=$CJ$1,BX11,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CVвстр-пр",{"$f":"IF(BX$22=$CJ$1,BX12,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Значение",null,{"$f":"IF(ABS(BX16)>=1000,ROUND(BX16/1000,1)&\"т. р.\",BX16)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"Значение",null,{"$f":"BX11","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"Значение",null,{"$f":"IF(ABS(BX4)>=1000,ROUND(BX4/1000,1)&\"k\",BX4)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Цена клика",{"$f":"IF(BX$22=$CJ$1,BX13,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Динамика",null,"х",{"$f":"IFERROR((BY16-BX16)/BX16,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,"Динамика",null,"х",{"$f":"IFERROR((BY11-BX11)/BX11,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,"Динамика",null,"х",{"$f":"IFERROR((BY4-BX4)/BX4,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Цена заявки",{"$f":"IF(BX$22=$CJ$1,BX14,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Цена клиента",{"$f":"IF(BX$22=$CJ$1,BX15,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Средн чек",{"$f":"IF(BX$22=$CJ$1,BX16,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROI",{"$f":"IF(BX$22=$CJ$1,BX17,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"прибыль (-затраты)",{"$f":"IF(BX$22=$CJ$1,BX18,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Чистая прибыль",{"$f":"IF(BX$22=$CJ$1,BX19,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Реклама",{"$f":"IF($DD$28,BX8,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Прочие затраты",{"$f":"IF($DD$29,BX9,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[null,null,"Значение",null,{"$f":"IF(ABS(BX7)>=1000,ROUND(BX7/1000,1)&\"т. р.\",BX7)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"Значение",null,{"$f":"IF(ABS(BX12)>=1000,ROUND(BX12/1000,1)&\"k\",BX12)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"Значение",null,{"$f":"IF(ABS(BX5)>=1000,ROUND(BX5/1000,1)&\"k\",BX5)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Динамика",null,"х",{"$f":"IFERROR((BY7-BX7)/BX7,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,"Динамика",null,"х",{"$f":"IFERROR((BY12-BX12)/BX12,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,"Динамика",null,"х",{"$f":"IFERROR((BY5-BX5)/BX5,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Реклама",null,{"$f":"IF(ABS(BX8)>=1000,ROUND(BX8/1000,1)&\"т. р.\",BX8)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"Значение",null,{"$f":"BX17","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"Значение",null,{"$f":"IF(ABS(BX6)>=1000,ROUND(BX6/1000,1)&\"k\",BX6)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Динамика",null,"х",{"$f":"IFERROR((BY8-BX8)/BX8,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,"Динамика",null,"х",{"$f":"IFERROR((BY17-BX17)/BX17,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,"Динамика",null,"х",{"$f":"IFERROR((BY6-BX6)/BX6,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Дп. Затр.",null,null,{"$f":"IF(ABS(BX9)>=1000,ROUND(BX9/1000,1)&\"т. р.\",BX9)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Динамика",null,"х",{"$f":"IFERROR((BY9-BX9)/BX9,0)","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"Прогнозирование","index":2,"n_rows":45,"n_cols":145,"rows_kept":45,"cut":false,"hidden":false,"merged":[[21,12,21,13],[2,28,2,29],[3,28,3,29],[2,17,2,19],[3,17,3,19],[4,17,4,19],[2,24,2,25],[3,26,3,27],[4,26,4,27],[3,24,3,25],[3,21,3,23],[4,21,4,23],[4,24,4,25],[2,21,2,23],[2,26,2,27],[2,11,2,12],[2,6,2,7],[3,6,3,7],[3,8,3,9],[4,6,4,7],[4,8,4,9],[2,8,2,9],[2,13,2,14],[3,11,3,12],[4,11,4,12],[2,15,2,16],[3,13,3,14],[4,13,4,14],[4,15,4,16],[3,15,3,16],[7,12,7,16],[36,8,38,15],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7],[8,12,8,13],[9,12,9,13],[10,12,10,13],[11,12,11,13],[12,12,12,13],[19,12,19,13],[20,12,20,13],[13,12,13,13],[14,12,14,13],[11,26,11,27],[12,26,12,27],[13,26,13,27],[7,34,7,35],[3,34,3,35],[4,34,4,35],[5,34,5,35],[6,34,6,35],[8,28,8,29],[4,28,4,29],[7,19,7,29],[35,5,35,7],[35,14,35,15],[27,25,27,26],[28,25,28,26],[31,26,32,26],[30,6,30,7],[31,6,31,7],[33,6,33,7],[34,6,34,7],[32,5,32,7],[30,19,34,25],[31,27,32,27],[25,23,25,26],[26,24,26,26],[17,19,20,20],[17,21,20,25],[20,26,20,27],[17,26,17,27],[18,26,18,27],[19,26,19,27],[6,5,6,10],[6,12,6,16],[6,19,6,29],[23,5,23,16],[0,13,1,15],[14,26,14,27],[15,26,15,27],[16,26,16,27],[8,26,8,27],[9,26,9,27],[10,26,10,27],[15,12,15,13],[16,12,16,13],[17,12,17,13],[18,12,18,13],[8,15,8,16]]}
[1,null,null,null,null,null,null,null,null,null,null,null,null,"Выберите месяц:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[{"$f":"Статистика!$CJ$1","v":1}]
[null,null,null,null,null,"Показатель","Янв",null,"Фев",null,"Мар","Апр",null,"Май",null,"Июн",null,"Июл",null,null,"Авг","Сен",null,null,"Окт",null,"Ноя",null,"Дек",null,null,null,null,null,null,null,null,1,6]
[null,null,null,null,null,"Факт",{"$f":"G44","v":0},null,{"$f":"H44","v":0},null,{"$f":"I44","v":0},{"$f":"J44","v":0},null,{"$f":"K44","v":0},null,{"$f":"L44","v":0},null,{"$f":"M44","v":0},null,null,{"$f":"N44","v":0},{"$f":"O44","v":0},null,null,{"$f":"P44","v":0},null,{"$f":"Q44","v":0},null,{"$f":"R44","v":0},null,178,"Прозрачно",178,null,180,null,null,{"$f":"MAX(AL5:AL7)","v":3},null,null,"% плана","Комментарий"]
[null,null,null,null,null,"Цель",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(MIN(177,180*AG9),0)","v":{"$error":"#VALUE!"}},"Красный",{"$f":"180*AH5/100","v":117},65,{"$f":"MIN(180*(AK8)-1,178)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(AG9>=AO6,3,0)","v":3},3,"Зеленый",null,"Ваших темпов хватает, скорее всего вы достигните вашей цели"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Желтый",{"$f":"180*AH6/100-AG5","v":45},90,2,null,1,{"$f":"IF(AND(AL7=0,AG9<AO6),2,0)","v":0},2,"Желтый",0.9,"Вам нужно ускориться для достижения вашей цели"]
[null,null,null,null,null,"Фактические данные месяца",null,null,null,null,null,null,"Анализ \"что будет если\"",null,null,null,null,null,null,"Декомпозиция цели на основе воронки",null,null,null,null,null,null,null,null,null,null,{"$f":"182-AE6-AE5","v":{"$error":"#VALUE!"}},"Зеленый",{"$f":"182-AG5-AG6","v":20},null,{"$f":"180-AI5-AI6","v":{"$error":"#DIV/0!"}},null,0,{"$f":"IF(AG9<AO7,1,0)","v":0},1,"Красный",0.65,"Ваших темпов пока недостаточно, чтобы дойти до цели"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A1=1,\"Анализ, что если к текущему моменту были бы другие значения\",\"Анализ что будет на конец месяца при следующих значениях\")","v":"Анализ, что если к текущему моменту были бы другие значения"},null,null,null,null,null,null,"Поиск способов достижения целевых показателей за счет изменения входных параметров",null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"факт\"","v":"факт"},{"$f":"OFFSET(F44,,A2)","v":0},{"$f":"ROUND(AI8/2,0)","v":0},{"$f":"OFFSET(F45,,A2)","v":0},null,{"$f":"AG8/AI8","v":{"$error":"#DIV/0!"}},{"$f":"K17/AF13","v":{"$error":"#DIV/0!"}},{"$f":"если","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,"Показатели","1 нед","2 нед","3 нед","4 нед","Итого",null,"Показатели",null,"∆","Результат",null,null,null,null,null,null,null,null,null,null,"Показатели",null,"Значения",null,null,null,{"$f":"IFERROR(AH9/AI8,\"-\")","v":"-"},{"$f":"E22","v":0},{"$f":"IF(AH8>1000,ROUND(AH8/1000,2)&\"т.р.\",ROUND(AH8,2)&\"р.\")","v":"0р."},{"$f":"IF(AI8>1000,ROUND(AI8/1000,2)&\"т.р.\",ROUND(AI8,2)&\"р.\")","v":"0р."}]
[0,{"$f":"IFERROR(OFFSET(БД!$K:$K,(B$23-1)*17+3+$A10-1,0,1,1),0)","v":0},{"$f":"IFERROR(OFFSET(БД!$K:$K,(C$23-1)*17+3+$A10-1,0,1,1),0)","v":0},{"$f":"IFERROR(OFFSET(БД!$K:$K,(D$23-1)*17+3+$A10-1,0,1,1),0)","v":0},null,"Клики",{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A10-1,0,1,1),0),AVERAGE(B10,C10,D10))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A10-1,0,1,1),0),AVERAGE(C10,D10,G10))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A10-1,0,1,1),0),AVERAGE(D10,G10,H10))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A10-1,0,1,1),0),AVERAGE(G10,H10,I10))","v":0},{"$f":"SUM(G10:J10)","v":0},300,"Клики",null,{"$f":"(L10-300)/500","v":0},null,{"$f":"K10*(1+O10)","v":0},null,null,null,null,null,null,null,null,null,"Клики",null,{"$f":"IF(AD10,AH15,K10)","v":0},{"$f":"IF($AM$3=AE10,1,0)","v":0},1,null,0,{"$f":"IF(AG8>1000,ROUND(AG8/1000,2)&\"т.р.\",ROUND(AG8,2)&\"р.\")","v":"0р."}]
[1,{"$f":"IFERROR(OFFSET(БД!$K:$K,(B$23-1)*17+3+$A11-1,0,1,1),0)","v":0},{"$f":"IFERROR(OFFSET(БД!$K:$K,(C$23-1)*17+3+$A11-1,0,1,1),0)","v":0},{"$f":"IFERROR(OFFSET(БД!$K:$K,(D$23-1)*17+3+$A11-1,0,1,1),0)","v":0},null,"Заявки",{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A11-1,0,1,1),0),AVERAGE(B11,C11,D11))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A11-1,0,1,1),0),AVERAGE(C11,D11,G11))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A11-1,0,1,1),0),AVERAGE(D11,G11,H11))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A11-1,0,1,1),0),AVERAGE(G11,H11,I11))","v":0},{"$f":"SUM(G11:J11)","v":0},300,"Заявки",null,{"$f":"(L11-300)/500","v":0},null,{"$f":"K12*Q10*(1+O11)","v":0},null,null,null,null,null,null,null,null,null,"Заявки",null,{"$f":"IF(AD11,K11/AL8,AC10*K12)","v":0},{"$f":"IF($AM$3=AE11,1,0)","v":0},2]
[null,null,null,null,null,"CVкл-заявки",{"$f":"IF(G10>0,G11/G10,0)","v":0},{"$f":"IF(H10>0,H11/H10,0)","v":0},{"$f":"IF(I10>0,I11/I10,0)","v":0},{"$f":"IF(J10>0,J11/J10,0)","v":0},{"$f":"IF(K10>0,K11/K10,0)","v":0},null,"CVкл-заявки",null,null,null,{"$f":"IF(Q10>0,Q11/Q10,0)","v":0},null,null,null,null,null,null,null,null,null,"CVкл-заявки",null,{"$f":"IF(AC10>0,AC11/AC10,0)","v":0}]
[2,{"$f":"IFERROR(OFFSET(БД!$K:$K,(B$23-1)*17+3+$A13-1,0,1,1),0)","v":0},{"$f":"IFERROR(OFFSET(БД!$K:$K,(C$23-1)*17+3+$A13-1,0,1,1),0)","v":0},{"$f":"IFERROR(OFFSET(БД!$K:$K,(D$23-1)*17+3+$A13-1,0,1,1),0)","v":0},null,"Встречи",{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A13-1,0,1,1),0),AVERAGE(B13,C13,D13))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A13-1,0,1,1),0),AVERAGE(C13,D13,G13))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A13-1,0,1,1),0),AVERAGE(D13,G13,H13))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A13-1,0,1,1),0),AVERAGE(G13,H13,I13))","v":0},0,300,"Встречи",null,{"$f":"(L13-300)/500","v":0},null,{"$f":"K14*Q11*(1+O13)","v":0},null,null,null,null,null,null,null,null,null,"Встречи",null,{"$f":"IF(AD13,K13/AL8,AC11*K14)","v":0},{"$f":"IF($AM$3=AE13,1,0)","v":0},3,{"$f":"AI8+K18+K19","v":0}]
[null,null,null,null,null,"CVзаяв-встр",{"$f":"IF(G11>0,G13/G11,0)","v":0},{"$f":"IF(H11>0,H13/H11,0)","v":0},{"$f":"IF(I11>0,I13/I11,0)","v":0},{"$f":"IF(J11>0,J13/J11,0)","v":0},{"$f":"IF(K11>0,K13/K11,0)","v":0},null,"CVзаяв-встр",null,null,null,{"$f":"IF(Q11>0,Q13/Q11,0)","v":0},null,null,null,null,null,null,null,null,null,"CVзаяв-встр",null,{"$f":"IF(AC11>0,AC13/AC11,0)","v":0},null,null,null,{"$f":"K16*K14*K12","v":0},{"$f":"AH15/K20","v":{"$error":"#DIV/0!"}},{"$f":"AH14/AG14","v":{"$error":"#DIV/0!"}}]
[3,{"$f":"IFERROR(OFFSET(БД!$K:$K,(B$23-1)*17+3+$A15-1,0,1,1),0)","v":0},{"$f":"IFERROR(OFFSET(БД!$K:$K,(C$23-1)*17+3+$A15-1,0,1,1),0)","v":0},{"$f":"IFERROR(OFFSET(БД!$K:$K,(D$23-1)*17+3+$A15-1,0,1,1),0)","v":0},null,"Продажи",{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A15-1,0,1,1),0),AVERAGE(B15,C15,D15))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A15-1,0,1,1),0),AVERAGE(C15,D15,G15))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A15-1,0,1,1),0),AVERAGE(D15,G15,H15))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A15-1,0,1,1),0),AVERAGE(G15,H15,I15))","v":0},0,300,"Продажи",null,{"$f":"(L15-300)/500","v":0},null,{"$f":"Q13*K16*(1+O15)","v":0},null,null,null,null,null,null,null,null,null,"Продажи",null,{"$f":"IF(AD15,K15/AL8,AC13*K16)","v":0},{"$f":"IF($AM$3=AE15,1,0)","v":0},4,null,{"$f":"K18/K10","v":{"$error":"#DIV/0!"}},{"$f":"MAX((K19+AI8)/(K20*AG14-AG15),K10)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"CVвстр-пр",{"$f":"IF(G13>0,G15/G13,0)","v":0},{"$f":"IF(H13>0,H15/H13,0)","v":0},{"$f":"IF(I13>0,I15/I13,0)","v":0},{"$f":"IF(J13>0,J15/J13,0)","v":0},{"$f":"IF(K13>0,K15/K13,0)","v":0},null,"CVвстр-пр",null,null,null,{"$f":"IF(Q13>0,Q15/Q13,0)","v":0},null,null,null,null,null,null,null,null,null,"CVвстр-пр",null,{"$f":"IF(AC13>0,AC15/AC13,0)","v":0},null,null,null,"Продажи",{"$f":"(AI8+AC18+AC19)/AC20","v":{"$error":"#DIV/0!"}}]
[4,{"$f":"IFERROR(OFFSET(БД!$K:$K,(B$23-1)*17+3+$A17-1,0,1,1),0)","v":0},{"$f":"IFERROR(OFFSET(БД!$K:$K,(C$23-1)*17+3+$A17-1,0,1,1),0)","v":0},{"$f":"IFERROR(OFFSET(БД!$K:$K,(D$23-1)*17+3+$A17-1,0,1,1),0)","v":0},null,"Выручка",{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A17-1,0,1,1),0),AVERAGE(B17,C17,D17))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A17-1,0,1,1),0),AVERAGE(C17,D17,G17))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A17-1,0,1,1),0),AVERAGE(D17,G17,H17))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A17-1,0,1,1),0),AVERAGE(G17,H17,I17))","v":0},0,300,"Выручка",null,{"$f":"(L17-300)/500","v":0},null,{"$f":"K17/K15*Q15*(1+O17)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"Выручка",null,{"$f":"AC20*AC15","v":0},null,null,null,null,{"$f":"AH16/AC16","v":{"$error":"#DIV/0!"}}]
[5,{"$f":"IFERROR(OFFSET(БД!$K:$K,(B$23-1)*17+3+$A18-1,0,1,1),0)","v":0},{"$f":"IFERROR(OFFSET(БД!$K:$K,(C$23-1)*17+3+$A18-1,0,1,1),0)","v":0},{"$f":"IFERROR(OFFSET(БД!$K:$K,(D$23-1)*17+3+$A18-1,0,1,1),0)","v":0},null,"Реклама",{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A18-1,0,1,1),0),AVERAGE(B18,C18,D18))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A18-1,0,1,1),0),AVERAGE(C18,D18,G18))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A18-1,0,1,1),0),AVERAGE(D18,G18,H18))","v":0},{"$f":"IF(OR($A$1=1,IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A18-1,0,1,1),0),AVERAGE(G18,H18,I18))","v":0},0,null,"Реклама",null,null,null,{"$f":"K18/K10*Q10","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IF(AI8=0,\"введите цель\",IFERROR(VLOOKUP(AL4,AM5:AP7,4,0),\"введите цель\"))","v":"введите цель"},null,null,null,null,"Реклама",null,{"$f":"IFERROR(K18/K10*AC10,0)","v":0}]
[{"$f":"IF(OR(0,IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A17-1,0,1,1),0),AVERAGE(B17,C17,D17))","v":0},{"$f":"IF(OR(0,IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A17-1,0,1,1),0),AVERAGE(C17,D17,A19))","v":0},{"$f":"IF(OR(0,IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A17-1,0,1,1),0),AVERAGE(D17,A19,B19))","v":0},{"$f":"IF(OR(0,IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A17-1,0,1,1),0),AVERAGE(A19,B19,C19))","v":0},{"$f":"SUM(A19:D19)","v":0},"Прочие затраты",{"$f":"$K$19/4","v":0},{"$f":"$K$19/4","v":0},0,0,{"$f":"SUM(OFFSET(БД!$N:$N,,$A$2*2))","v":0},300,"Прочие затраты",null,{"$f":"(L19-300)/500","v":0},null,{"$f":"K19*(1+O19)","v":0},null,null,null,null,null,null,null,null,null,"Прочие затраты",null,{"$f":"K19","v":0}]
[{"$f":"IF(OR(0,IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(G$23-1)*17+3+$A18-1,0,1,1),0),AVERAGE(B18,C18,D18))","v":0},{"$f":"IF(OR(0,IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(H$23-1)*17+3+$A18-1,0,1,1),0),AVERAGE(C18,D18,A20))","v":0},{"$f":"IF(OR(0,IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(I$23-1)*17+3+$A18-1,0,1,1),0),AVERAGE(D18,A20,B20))","v":0},{"$f":"IF(OR(0,IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A$10-1,0,1,1),0)),IFERROR(OFFSET(БД!$K:$K,(J$23-1)*17+3+$A18-1,0,1,1),0),AVERAGE(A20,B20,C20))","v":0},{"$f":"SUM(A20:D20)","v":0},"Средн чек",{"$f":"IF(G15>0,G17/G15,0)","v":0},{"$f":"IF(H15>0,H17/H15,0)","v":0},{"$f":"IF(I15>0,I17/I15,0)","v":0},{"$f":"IF(J15>0,J17/J15,0)","v":0},{"$f":"IF(K15>0,K17/K15,0)","v":0},null,"Средн чек",null,{"$f":"(L17-300)/500","v":0},null,{"$f":"IF(Q15>0,Q17/Q15,0)","v":0},null,null,null,null,null,null,null,null,null,"Средн чек",null,{"$f":"IF(AD20,K20/AL8,K20)","v":0},{"$f":"IF($AM$3=AE20,1,0)","v":0},5]
[null,null,null,null,{"$f":"SUM(OFFSET(БД!$N:$N,,$A$2*2))","v":0},"Чистая прибыль",{"$f":"G17-G18-G19","v":0},{"$f":"H17-H18-H19","v":0},0,0,{"$f":"K17-K18-K19","v":0},null,"Чистая прибыль",null,{"$f":"(Q21-K21)/K21","v":{"$error":"#DIV/0!"}},{"$f":"IF((Q21-K21)>0,\"+\",\"\")&TEXT(ROUND(Q21-K21,0),\"# ##\") &\"р.\"","v":{"$error":"#DIV/0!"}},{"$f":"Q17-Q18-Q19","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"Чистая прибыль",null,{"$f":"AC17-AC18-AC19","v":0}]
[null,null,null,null,{"$f":"E19-E20-E21","v":0},null,{"$f":"SUM(G10:G11,G13,G15,G17:G18)","v":0},{"$f":"SUM(H10:H11,H13,H15,H17:H18)","v":0},0,0]
[null,{"$f":"MAX(0,G23-3)","v":0},{"$f":"MAX(0,H23-3)","v":0},{"$f":"MAX(0,I23-3)","v":0},null,null,{"$f":"($A$2-1)*4+1","v":1},{"$f":"($A$2-1)*4+2","v":2},{"$f":"($A$2-1)*4+3","v":3},{"$f":"($A$2-1)*4+4","v":4}]
[null,null,null,null,null,"Декомпозиция цели на основе свободных данных",null,null,null,null,null,null,null,null,null,null,null,null,null,"Другие продукты от автора воронки продаж 5.0"]
[]
[null,null,null,{"$f":"G26","v":35000},null,"Подберите цель, руб.",35000,null,{"$f":"VALUE(D26)","v":35000},null,null,null,null,null,null,null,null,null,null,"http://kurstargeting.ru",null,null,null,{"$f":"\"Показы CTR рекламы \"&I32*100&\"%:   \" & IFERROR(INT(AB26),0)","v":"Показы CTR рекламы 6%:   5063"},null,null,null,{"$f":"IF(I32=0,\"нет\",AB27/I32)","v":5063.6574074074069}]
[null,null,null,5000,null,"Введите среднюю выручку с 1 продажи, руб.",5000,null,{"$f":"VALUE(D27)","v":5000},null,null,null,null,null,null,null,null,null,null,"http://kursdirect.ru",null,null,null,null,{"$f":"\"Клики конверсия сайта \"&I29*100&\"%:   \" & IFERROR(INT(AB27),0)","v":"Клики конверсия сайта 12%:   303"},null,null,{"$f":"IF(I29=0,\"нет\",AB28/I29)","v":303.8194444444444}]
[null,null,null,3000,null,"Введите сколько чистыми с 1 продажи, руб.",3000,null,{"$f":"VALUE(D28)","v":3000},null,null,null,null,null,null,null,null,null,null,"Официальная группа воронки продаж",null,null,null,null,null,{"$f":"\"Звонки отклик-догов. \"&I30*100&\"%:   \" & IFERROR(INT(AB28),0)","v":"Звонки отклик-догов. 80%:   36"},null,{"$f":"IF(I30=0,\"нет\",AB29/I30)","v":36.458333333333329}]
[null,null,null,12,null,"Введите конверсию сайта в звонок/заявку %",12,null,{"$f":"VALUE(D29)/100","v":0.12},null,null,null,null,null,null,null,null,null,null,"http://vk.com/voronkaprodazh",null,null,null,null,null,{"$f":"\"Договоры догов.-прод. \"&I31*100&\"%:   \" & IFERROR(INT(AB29),0)","v":"Договоры догов.-прод. 40%:   29"},null,{"$f":"IF(I31=0,\"нет\",AB30/I31)","v":29.166666666666664}]
[null,null,null,80,null,"Введите конверсию заявка-договор %",80,null,{"$f":"VALUE(D30)/100","v":0.8},null,null,null,null,null,null,null,null,null,null,"Правила использования",null,null,null,null,null,null,{"$f":"\"Продажи:   \" & IFERROR(INT(AB30),0)","v":"Продажи:   11"},{"$f":"IF(AB31=0,\"нет\",AB32/AB31)","v":11.666666666666666}]
[null,null,null,40,null,"Введите конверсию договор-продажа %",40,null,{"$f":"VALUE(D31)/100","v":0.4},null,null,null,null,null,null,null,null,null,null,"Данный файл является авторским продуктом, все права принадлежат автору. Новиков Е.А. (vk.com/truejacko). Распространение и передача воронки продаж 5.0 третим лицам запрещена. В случае обнаружения случаев незаконного распространения - просьба обратиться к автору, написав на мейл info@kursdirect.ru",null,null,null,null,null,null,{"$f":"\"Ср. прибыль с 1 продажи:   \" & IFERROR(INT(AB31),0)","v":"Ср. прибыль с 1 продажи:   3000"},{"$f":"I28","v":3000}]
[null,null,null,6,null,"Введите CTR вашей рекламы %",6,null,{"$f":"VALUE(D32)/100","v":0.06},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Денег до вычета:   \n\" & IFERROR(INT(AB32),0)","v":"Денег до вычета:   \n35000"},{"$f":"I26","v":35000}]
[]
[null,null,null,{"$f":"G34","v":10},null,"Введите цену клика, руб.",10,null,{"$f":"VALUE(D34)","v":10},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Затраты на рекламу:   \n\" & IFERROR(INT(AB34),0)","v":"Затраты на рекламу:   \n2126"},{"$f":"IF(I34=0,\"0\",AB27*I34*I35)","v":2126.7361111111104}]
[null,null,null,{"$f":"G35","v":70},null,"% платного трафика",70,null,{"$f":"VALUE(D35/100)","v":0.7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Останется чистыми:   \n\" & IFERROR(INT(AB35),0)","v":"Останется чистыми:   \n32873"},{"$f":"IF(AB32=0,\"0\",AB32-AB34)","v":32873.263888888891}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Показатель","Янв","Фев","Мар","Апр","Май","Июн","Июл","Авг","Сен","Окт","Ноя","Дек"]
[null,null,null,null,null,"Факт",{"$f":"IFERROR(Статистика!BX19,0)","v":0},{"$f":"IFERROR(Статистика!BY19,0)","v":0},{"$f":"IFERROR(Статистика!BZ19,0)","v":0},{"$f":"IFERROR(Статистика!CA19,0)","v":0},{"$f":"IFERROR(Статистика!CB19,0)","v":0},{"$f":"IFERROR(Статистика!CC19,0)","v":0},{"$f":"IFERROR(Статистика!CD19,0)","v":0},{"$f":"IFERROR(Статистика!CE19,0)","v":0},{"$f":"IFERROR(Статистика!CF19,0)","v":0},{"$f":"IFERROR(Статистика!CG19,0)","v":0},{"$f":"IFERROR(Статистика!CH19,0)","v":0},{"$f":"IFERROR(Статистика!CI19,0)","v":0}]
[null,null,null,null,null,"Цель",{"$f":"G5","v":0},{"$f":"I5","v":0},{"$f":"K5","v":0},{"$f":"L5","v":0},{"$f":"N5","v":0},{"$f":"P5","v":0},{"$f":"R5","v":0},{"$f":"U5","v":0},{"$f":"V5","v":0},{"$f":"Y5","v":0},{"$f":"AA5","v":0},{"$f":"AC5","v":0}]

{"sheet":"БД","index":3,"n_rows":817,"n_cols":37,"rows_kept":817,"cut":false,"hidden":true,"merged":[[0,14,0,15],[0,16,0,17],[0,18,0,19],[0,20,0,21],[0,22,0,23],[0,36,0,37],[0,24,0,25],[0,26,0,27],[0,28,0,29],[0,30,0,31],[0,32,0,33],[0,34,0,35]]}
[null,null,null,null,null,null,null,null,null,null,"add",null,null,null,"Январь",null,"Февраль",null,"Март",null,"Апрель",null,"Май",null,"Июнь",null,"Июль",null,"Август",null,"Сентябрь",null,"Октябрь",null,"Ноябрь",null,"Декабрь"]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Январь неделя 1 (01-10 янв.)"},{"$f":"'Учет данных'!B4","v":0},{"$f":"'Учет данных'!C4","v":0},{"$f":"'Учет данных'!D4","v":0},{"$f":"'Учет данных'!E4","v":0},{"$f":"'Учет данных'!F4","v":0},{"$f":"'Учет данных'!G4","v":0},{"$f":"'Учет данных'!H4","v":0},{"$f":"'Учет данных'!I4","v":0},{"$f":"'Учет данных'!J4","v":0},{"$f":"'Учет данных'!K4","v":0},null,null,1]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B3:J3)","v":0},null,null,2]
["Заявки",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B4:J4)","v":0},null,null,3]
["Встречи",null,null,null,null,null,null,null,null,null,0,null,null,4]
["Продажи",null,null,null,null,null,null,null,null,null,0,null,null,5]
["Выручка",null,null,null,null,null,null,null,null,null,0,null,null,6]
["затраты",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B8:J8)","v":0},null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,8]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K3>0,K4/K3,0)","v":0},null,null,9]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,{"$f":"IF(K4>0,K5/K4,0)","v":0},null,null,10]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,{"$f":"IF(K5>0,K6/K5,0)","v":0},null,null,11]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K3>0,K$8/K3,0)","v":0},null,null,12]
["Цена заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K4>0,K$8/K4,0)","v":0},null,null,13]
["Цена клиента",null,null,null,null,null,null,null,null,null,{"$f":"IF(K5>0,K$8/K5,0)","v":0},null,null,14]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K6>0,K7/K6,0)","v":0},null,null,15]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K8>0,(K7-K8)/K8,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K7-K8","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Январь неделя 2 (11-17 янв.)"},{"$f":"B$2","v":0},{"$f":"C$2","v":0},0,0,0,0,0,0,0,{"$f":"'Учет данных'!K21","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B20:J20)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B21:J21)","v":0}]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K20>0,K21/K20,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K20>0,K$8/K20,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K23>0,K24/K23,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K25>0,(K24-K25)/K25,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K24-K25","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Январь неделя 3 (18-24 янв.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K38","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B37:J37)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K37>0,K38/K37,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K37>0,K$8/K37,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K40>0,K41/K40,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K42>0,(K41-K42)/K42,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K41-K42","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Январь неделя 4 (25-31 янв.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K55","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B54:J54)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K54>0,K55/K54,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K54>0,K$8/K54,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K57>0,K58/K57,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K59>0,(K58-K59)/K59,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K58-K59","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Февраль неделя 1 (01-07 фев.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K72","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B71:J71)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B76:J76)","v":0}]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K71>0,K72/K71,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K71>0,K$8/K71,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K74>0,K75/K74,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K76>0,(K75-K76)/K76,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K75-K76","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Февраль неделя 2 (08-14 фев.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K89","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B88:J88)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B89:J89)","v":0}]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K88>0,K89/K88,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K88>0,K$8/K88,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K91>0,K92/K91,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K93>0,(K92-K93)/K93,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K92-K93","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Февраль неделя 3 (15-21 фев.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K106","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B105:J105)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K105>0,K106/K105,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K105>0,K$8/K105,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K108>0,K109/K108,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K110>0,(K109-K110)/K110,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K109-K110","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Февраль неделя 4 (22-29 фев.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K123","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B122:J122)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K122>0,K123/K122,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K122>0,K$8/K122,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K125>0,K126/K125,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K127>0,(K126-K127)/K127,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K126-K127","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Март неделя 1 (01-06 мар.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K140","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B139:J139)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B144:J144)","v":0}]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K139>0,K140/K139,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K139>0,K$8/K139,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K142>0,K143/K142,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K144>0,(K143-K144)/K144,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K143-K144","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Март неделя 2 (07-13 мар.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K157","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B156:J156)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B157:J157)","v":0}]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B161:J161)","v":0}]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K156>0,K157/K156,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K156>0,K$8/K156,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K159>0,K160/K159,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K161>0,(K160-K161)/K161,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K160-K161","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Март неделя 3 (14-20 мар.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K174","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B173:J173)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B178:J178)","v":0}]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K173>0,K174/K173,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K173>0,K$8/K173,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K176>0,K177/K176,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K178>0,(K177-K178)/K178,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K177-K178","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Март неделя 4 (21-31 мар.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K191","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B190:J190)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B195:J195)","v":0}]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K190>0,K191/K190,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K190>0,K$8/K190,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K193>0,K194/K193,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K195>0,(K194-K195)/K195,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K194-K195","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Апрель неделя 1 (01-10 апр.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K208","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B207:J207)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B212:J212)","v":0}]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K207>0,K208/K207,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K207>0,K$8/K207,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K210>0,K211/K210,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K212>0,(K211-K212)/K212,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K211-K212","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Апрель неделя 2 (11-17 апр.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K225","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B224:J224)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B225:J225)","v":0}]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B229:J229)","v":0}]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K224>0,K225/K224,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K224>0,K$8/K224,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K227>0,K228/K227,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K229>0,(K228-K229)/K229,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K228-K229","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Апрель неделя 3 (18-24 апр.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K242","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B241:J241)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B246:J246)","v":0}]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K241>0,K242/K241,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K241>0,K$8/K241,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K244>0,K245/K244,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K246>0,(K245-K246)/K246,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K245-K246","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Апрель неделя 4 (25-30 апр.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K259","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B258:J258)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K258>0,K259/K258,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K258>0,K$8/K258,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K261>0,K262/K261,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K263>0,(K262-K263)/K263,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K262-K263","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Май неделя 1 (01-08 мая)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K276","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B275:J275)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K275>0,K276/K275,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K275>0,K$8/K275,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K278>0,K279/K278,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K280>0,(K279-K280)/K280,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K279-K280","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Май неделя 2 (09-15 мая)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K293","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B292:J292)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B293:J293)","v":0}]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K292>0,K293/K292,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K292>0,K$8/K292,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K295>0,K296/K295,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K297>0,(K296-K297)/K297,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K296-K297","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Май неделя 3 (16-22 мая)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K310","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B309:J309)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K309>0,K310/K309,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K309>0,K$8/K309,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K312>0,K313/K312,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K314>0,(K313-K314)/K314,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K313-K314","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Май неделя 4 (23-31 мая)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K327","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B326:J326)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K326>0,K327/K326,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K326>0,K$8/K326,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K329>0,K330/K329,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K331>0,(K330-K331)/K331,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K330-K331","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Июнь неделя 1 (01-05 июн.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K344","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B343:J343)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K343>0,K344/K343,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K343>0,K$8/K343,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K346>0,K347/K346,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K348>0,(K347-K348)/K348,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K347-K348","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Июнь неделя 2 (06-12 июн.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K361","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B360:J360)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B361:J361)","v":0}]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K360>0,K361/K360,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K360>0,K$8/K360,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K363>0,K364/K363,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K365>0,(K364-K365)/K365,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K364-K365","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Июнь неделя 3 (13-19 июн.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K378","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B377:J377)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K377>0,K378/K377,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K377>0,K$8/K377,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K380>0,K381/K380,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K382>0,(K381-K382)/K382,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K381-K382","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Июнь неделя 4 (20-3 июн.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K395","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B394:J394)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K394>0,K395/K394,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K394>0,K$8/K394,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K397>0,K398/K397,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K399>0,(K398-K399)/K399,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K398-K399","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Июль неделя 1 (01-10 июл.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K412","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B411:J411)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K411>0,K412/K411,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K411>0,K$8/K411,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K414>0,K415/K414,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K416>0,(K415-K416)/K416,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K415-K416","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Июль неделя 2 (11-17 июл.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K429","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B428:J428)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B429:J429)","v":0}]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K428>0,K429/K428,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K428>0,K$8/K428,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K431>0,K432/K431,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K433>0,(K432-K433)/K433,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K432-K433","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Июль неделя 3 (18-24 июл.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K446","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B445:J445)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K445>0,K446/K445,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K445>0,K$8/K445,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K448>0,K449/K448,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K450>0,(K449-K450)/K450,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K449-K450","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Июль неделя 4 (25-1 июл.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K463","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B462:J462)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K462>0,K463/K462,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K462>0,K$8/K462,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K465>0,K466/K465,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K467>0,(K466-K467)/K467,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K466-K467","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Август неделя 1 (01-07 авг.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K480","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B479:J479)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K479>0,K480/K479,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K479>0,K$8/K479,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K482>0,K483/K482,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K484>0,(K483-K484)/K484,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K483-K484","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Август неделя 2 (08-14 авг.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K497","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B496:J496)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B497:J497)","v":0}]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K496>0,K497/K496,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K496>0,K$8/K496,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K499>0,K500/K499,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K501>0,(K500-K501)/K501,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K500-K501","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Август неделя 3 (15-21 авг.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K514","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B513:J513)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K513>0,K514/K513,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K513>0,K$8/K513,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K516>0,K517/K516,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K518>0,(K517-K518)/K518,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K517-K518","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Август неделя 4 (22-31 авг.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K531","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B530:J530)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K530>0,K531/K530,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K530>0,K$8/K530,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K533>0,K534/K533,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K535>0,(K534-K535)/K535,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K534-K535","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Сентябрь неделя 1 (01-11 сен.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K548","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B547:J547)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K547>0,K548/K547,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K547>0,K$8/K547,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K550>0,K551/K550,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K552>0,(K551-K552)/K552,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K551-K552","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Сентябрь неделя 2 (12-18 сен.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K565","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B564:J564)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B565:J565)","v":0}]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K564>0,K565/K564,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K564>0,K$8/K564,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K567>0,K568/K567,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K569>0,(K568-K569)/K569,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K568-K569","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Сентябрь неделя 3 (19-25 сен.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K582","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B581:J581)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K581>0,K582/K581,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K581>0,K$8/K581,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K584>0,K585/K584,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K586>0,(K585-K586)/K586,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K585-K586","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Сентябрь неделя 4 (26-30 сен.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K599","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B598:J598)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K598>0,K599/K598,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K598>0,K$8/K598,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K601>0,K602/K601,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K603>0,(K602-K603)/K603,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K602-K603","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Октябрь неделя 1 (01-09 окт.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K616","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B615:J615)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K615>0,K616/K615,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K615>0,K$8/K615,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K618>0,K619/K618,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K620>0,(K619-K620)/K620,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K619-K620","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Октябрь неделя 2 (10-16 окт.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K633","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B632:J632)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B633:J633)","v":0}]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K632>0,K633/K632,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K632>0,K$8/K632,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K635>0,K636/K635,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K637>0,(K636-K637)/K637,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K636-K637","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Октябрь неделя 3 (17-23 окт.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K650","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B649:J649)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K649>0,K650/K649,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K649>0,K$8/K649,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K652>0,K653/K652,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K654>0,(K653-K654)/K654,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K653-K654","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Октябрь неделя 4 (24-31 окт.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K667","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B666:J666)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K666>0,K667/K666,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K666>0,K$8/K666,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K669>0,K670/K669,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K671>0,(K670-K671)/K671,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K670-K671","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Ноябрь неделя 1 (01-06 ноя.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K684","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B683:J683)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K683>0,K684/K683,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K683>0,K$8/K683,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K686>0,K687/K686,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K688>0,(K687-K688)/K688,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K687-K688","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Ноябрь неделя 2 (07-13 ноя.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K701","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B700:J700)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B701:J701)","v":0}]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K700>0,K701/K700,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K700>0,K$8/K700,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K703>0,K704/K703,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K705>0,(K704-K705)/K705,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K704-K705","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Ноябрь неделя 3 (14-20 ноя.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K718","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B717:J717)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K717>0,K718/K717,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K717>0,K$8/K717,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K720>0,K721/K720,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K722>0,(K721-K722)/K722,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K721-K722","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Ноябрь неделя 4 (21-30 ноя.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K735","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B734:J734)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K734>0,K735/K734,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K734>0,K$8/K734,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K737>0,K738/K737,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K739>0,(K738-K739)/K739,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K738-K739","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Декабрь неделя 1 (01-11 дек.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K752","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B751:J751)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K751>0,K752/K751,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K751>0,K$8/K751,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K754>0,K755/K754,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K756>0,(K755-K756)/K756,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K755-K756","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Декабрь неделя 2 (12-18 дек.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K769","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B768:J768)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B769:J769)","v":0}]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K768>0,K769/K768,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K768>0,K$8/K768,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K771>0,K772/K771,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K773>0,(K772-K773)/K773,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K772-K773","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Декабрь неделя 3 (19-25 дек.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K786","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B785:J785)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K785>0,K786/K785,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K785>0,K$8/K785,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K788>0,K789/K788,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K790>0,(K789-K790)/K790,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K789-K790","v":0}]
[{"$f":"VLOOKUP(INT((ROW()-1)/17)+1,Справочник!A:D,3,0)","v":"Декабрь неделя 4 (26-31 дек.)"},{"$f":"B$2","v":0},0,0,0,0,0,0,0,0,{"$f":"'Учет данных'!K803","v":0}]
["Клики",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B802:J802)","v":0}]
["Заявки",null,null,null,null,null,null,null,null,null,0]
["Встречи",null,null,null,null,null,null,null,null,null,0]
["Продажи",null,null,null,null,null,null,null,null,null,0]
["Выручка",null,null,null,null,null,null,null,null,null,0]
["затраты",null,null,null,null,null,null,null,null,null,0]
[]
["CVкл-заявки",null,null,null,null,null,null,null,null,null,{"$f":"IF(K802>0,K803/K802,0)","v":0}]
["CVзаяв-встр",null,null,null,null,null,null,null,null,null,0]
["CVвстр-пр",null,null,null,null,null,null,null,null,null,0]
["Цена клика",null,null,null,null,null,null,null,null,null,{"$f":"IF(K802>0,K$8/K802,0)","v":0}]
["Цена заявки",null,null,null,null,null,null,null,null,null,0]
["Цена клиента",null,null,null,null,null,null,null,null,null,0]
["Средн чек",null,null,null,null,null,null,null,null,null,{"$f":"IF(K805>0,K806/K805,0)","v":0}]
["ROI",null,null,null,null,null,null,null,null,null,{"$f":"IF(K807>0,(K806-K807)/K807,0)","v":0}]
["прибыль (-затраты)",null,null,null,null,null,null,null,null,null,{"$f":"K806-K807","v":0}]

{"sheet":"Справочник","index":4,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["№","Неделя","Описание","Месяц","Месяц",null,1,"Клики",1,null,null,null,null,"Месяц"]
[1,"Январь неделя 1","Январь неделя 1 (01-10 янв.)",1,{"$f":"LEFT(B2,SEARCH(\" \",B2)-1)","v":"Январь"},null,2,"Заявки",2,null,null,null,1,"Январь",1]
[2,"Январь неделя 2","Январь неделя 2 (11-17 янв.)",1,{"$f":"LEFT(B3,SEARCH(\" \",B3)-1)","v":"Январь"},null,3,"Встречи",3,null,null,null,2,"Февраль",2]
[3,"Январь неделя 3","Январь неделя 3 (18-24 янв.)",1,"Январь",null,4,"Продажи",4,null,null,null,3,"Март",3]
[4,"Январь неделя 4","Январь неделя 4 (25-31 янв.)",1,"Январь",null,5,"Выручка",5,"д2",null,null,4,"Апрель",4]
[5,"Февраль неделя 1","Февраль неделя 1 (01-07 фев.)",2,"Февраль",null,6,"затраты",6,"д2",null,null,5,"Май",5]
[6,"Февраль неделя 2","Февраль неделя 2 (08-14 фев.)",2,"Февраль",null,7,"CVклили-заявки",8,"пр",null,null,6,"Июнь",6]
[7,"Февраль неделя 3","Февраль неделя 3 (15-21 фев.)",2,"Февраль",null,8,"CVзаявки-встречи",9,"пр",null,null,7,"Июль",7]
[8,"Февраль неделя 4","Февраль неделя 4 (22-29 фев.)",2,"Февраль",null,9,"CVвстречи-продажи",10,"пр",null,null,8,"Август",8]
[9,"Март неделя 1","Март неделя 1 (01-06 мар.)",3,"Март",null,10,"Цена клика",11,"д",null,null,9,"Сентябрь",9]
[10,"Март неделя 2","Март неделя 2 (07-13 мар.)",3,"Март",null,11,"Цена заявки",12,"д",null,null,10,"Октябрь",10]
[11,"Март неделя 3","Март неделя 3 (14-20 мар.)",3,"Март",null,12,"Цена клиента",13,"д",null,null,11,"Ноябрь",11]
[12,"Март неделя 4","Март неделя 4 (21-31 мар.)",3,"Март",null,13,"Средн чек",14,"д2",null,null,12,"Декабрь",12]
[13,"Апрель неделя 1","Апрель неделя 1 (01-10 апр.)",4,"Апрель",null,14,"ROI",15,"пр2"]
[14,"Апрель неделя 2","Апрель неделя 2 (11-17 апр.)",4,"Апрель",null,15,"прибыль (-затраты)",16,"д2"]
[15,"Апрель неделя 3","Апрель неделя 3 (18-24 апр.)",4,"Апрель"]
[16,"Апрель неделя 4","Апрель неделя 4 (25-30 апр.)",4,"Апрель"]
[17,"Май неделя 1","Май неделя 1 (01-08 мая)",5,"Май"]
[18,"Май неделя 2","Май неделя 2 (09-15 мая)",5,"Май"]
[19,"Май неделя 3","Май неделя 3 (16-22 мая)",5,"Май"]
[20,"Май неделя 4","Май неделя 4 (23-31 мая)",5,"Май"]
[21,"Июнь неделя 1","Июнь неделя 1 (01-05 июн.)",6,"Июнь"]
[22,"Июнь неделя 2","Июнь неделя 2 (06-12 июн.)",6,"Июнь"]
[23,"Июнь неделя 3","Июнь неделя 3 (13-19 июн.)",6,"Июнь"]
[24,"Июнь неделя 4","Июнь неделя 4 (20-3 июн.)",6,"Июнь"]
[25,"Июль неделя 1","Июль неделя 1 (01-10 июл.)",7,"Июль"]
[26,"Июль неделя 2","Июль неделя 2 (11-17 июл.)",7,"Июль"]
[27,"Июль неделя 3","Июль неделя 3 (18-24 июл.)",7,"Июль"]
[28,"Июль неделя 4","Июль неделя 4 (25-1 июл.)",7,"Июль"]
[29,"Август неделя 1","Август неделя 1 (01-07 авг.)",8,"Август"]
[30,"Август неделя 2","Август неделя 2 (08-14 авг.)",8,"Август"]
[31,"Август неделя 3","Август неделя 3 (15-21 авг.)",8,"Август"]
[32,"Август неделя 4","Август неделя 4 (22-31 авг.)",8,"Август"]
[33,"Сентябрь неделя 1","Сентябрь неделя 1 (01-11 сен.)",9,"Сентябрь"]
[34,"Сентябрь неделя 2","Сентябрь неделя 2 (12-18 сен.)",9,"Сентябрь"]
[35,"Сентябрь неделя 3","Сентябрь неделя 3 (19-25 сен.)",9,"Сентябрь"]
[36,"Сентябрь неделя 4","Сентябрь неделя 4 (26-30 сен.)",9,"Сентябрь"]
[37,"Октябрь неделя 1","Октябрь неделя 1 (01-09 окт.)",10,"Октябрь"]
[38,"Октябрь неделя 2","Октябрь неделя 2 (10-16 окт.)",10,"Октябрь"]
[39,"Октябрь неделя 3","Октябрь неделя 3 (17-23 окт.)",10,"Октябрь"]
[40,"Октябрь неделя 4","Октябрь неделя 4 (24-31 окт.)",10,"Октябрь"]
[41,"Ноябрь неделя 1","Ноябрь неделя 1 (01-06 ноя.)",11,"Ноябрь"]
[42,"Ноябрь неделя 2","Ноябрь неделя 2 (07-13 ноя.)",11,"Ноябрь"]
[43,"Ноябрь неделя 3","Ноябрь неделя 3 (14-20 ноя.)",11,"Ноябрь"]
[44,"Ноябрь неделя 4","Ноябрь неделя 4 (21-30 ноя.)",11,"Ноябрь"]
[45,"Декабрь неделя 1","Декабрь неделя 1 (01-11 дек.)",12,"Декабрь"]
[46,"Декабрь неделя 2","Декабрь неделя 2 (12-18 дек.)",12,"Декабрь"]
[47,"Декабрь неделя 3","Декабрь неделя 3 (19-25 дек.)",12,"Декабрь"]
[48,"Декабрь неделя 4","Декабрь неделя 4 (26-31 дек.)",12,"Декабрь"]

{"sheet":"for_code","index":5,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Week",1]
["Type",1]